Database reference guide

HOME

Cerberus [SYSTEM] options

Listed below are the valid [SYSTEM] options, in alphabetical order. Edit these settings using the Management Console's Engine Configuration applet.

CTypeLocale Description Sets the language locale to use for upper, lower and proper case expressions and object names.
Part CTypeLocale = [VALUE]
Default English
Remarks [VALUE] must be a valid language setting as shown in Windows Control Panel's Regional and Language Options. When Engine starts up, the cerlog reports the language that has been selected.
Example

For example, the following specification in the SYSTEM section of the Cerberus.ini file: CTypeLocale=German

results in this cerlog message:

[000003][03804] 06/09 16:15:18 INFORMATION Changing ctype locale to : German_Germany.1252

LogFile Description The path and file name of a log file that Engine will output messages to. Usually, the file is called CERLOG.TXT.
Part LOGFILE = [VALUE]
Default The root of the current repository.
MaxConnectionAttempts Description The maximum number of attempts users have to log in before their account is locked.
Part

MaxConnectionAttempts = [VALUE]

Min = 0

Max = unlimited

Default 3
MaxConnectionAttemptsSys Description The maximum number of attempts System users have to log in before their account is locked.
Part

MaxConnectionAttemptsSys = [VALUE]

Min = 0

Max = unlimited

Default 1000
NewNullRepresentation Description If OFF, stores nulls in Real fields as -2130706432. If ON, stores nulls in Real fields as -1.797693134862315807e308, this prevents any ambiguity with negative numbers.
Part

NewNullRepresentation = [VALUE]

0: OFF

1: ON

Default 0: OFF
Remarks

It is recommended that this setting is set to ON for all new databases. It should not be altered once data has been loaded.

See also: Data type limits and constraints.

NumericLocale Description Specifies Locale numeric format for Engine import and export.
Part

NumericLocale = [STRING]

Country code, for example, Spanish.

Default None.
SparseArrays Description If ON, allows the use of Sparse Arrays.
Part

SparseArrays = [VALUE]

ON: Sparse Arrays can be used

OFF: Sparse Arrays cannot be used and the message "Not Enough Memory For Crosstab" may appear in the cerlog.

Default OFF
Remarks

Sparse arrays are used when calculating large crosstabs where many of the rows are blank and may be essential on larger systems.

SystemDateFormat Description Sets the System Date Format. This is the format in which DATE fields are used in expressions and queries.
Part

SystemDateFormat = [VALUE]

  • 0 : CCYYMMDD
  • 1 : DDMMCCYY
  • 2 : CCYYDDMM
  • 3 : MMDDCCYY
  • 4 : DDMMYY
  • 5 : MMDDYY
  • 6 : DDMMMCCYY
Default 1
Remarks

All date fields must be re-imported if the setting is changed, as it affects the internal storage.

SystemDateTimeFormat Description Sets the System DateTime Format. This is the format in which DATETIME fields are used in expressions and queries.
Part

SystemDateTimeFormat = [VALUE]

  • 00 : CCYYMMDD HHMMSS
  • 01 : CCYYMMDD HHMM
  • 02 : CCYYMMDD HH:MM:SS
  • 03 : CCYYMMDD HH:MM
  • 04 : DDMMCCYY HHMMSS
  • 05 : DDMMCCYY HHMM
  • 06 : DDMMCCYY HH:MM:SS
  • 07 : DDMMCCYY HH:MM
  • 08 : CCYYDDMM HHMMSS
  • 09 : CCYYDDMM HHMM
  • 10 : CCYYDDMM HH:MM:SS
  • 11 : CCYYDDMM HH:MM
  • 12 : MMDDCCYY HHMMSS
  • 13 : MMDDCCYY HHMM
  • 14 : MMDDCCYY HH:MM:SS
  • 15 : MMDDCCYY HH:MM
  • 16 : DDMMYY HHMMSS
  • 17 : DDMMYY HHMM
  • 18 : DDMMYY HH:MM:SS
  • 19 : DDMMYY HH:MM
  • 20 : MMDDYY HHMMSS
  • 21 : MMDDYY HHMM
  • 22 : MMDDYY HH:MM:SS
  • 23 : MMDDYY HH:MM
  • 24 : DDMMMCCYY HHMMSS
  • 25 : DDMMMCCYY HHMM
  • 26 : DDMMMCCYY HH:MM:SS
  • 27 : DDMMMCCYY HH:MM
Default 2
Remarks

When DATETIME formats are passed as strings to Engine (for example, in ITable.AddField or IField.Format), the colon (:) must be replaced by a space ( ) or Engine will raise an Invalid Format error.

SystemTimeFormat Description Sets the System Time Format. This is the format in which TIME fields are used in expressions and queries.
Part

SystemTimeFormat = [VALUE]

  • 0 : HHMMSS
  • 1 : HHMM
  • 2 : HH:MM:SS
  • 3 : HH:MM
Default 2
Remarks

The System Time Format will be overridden by the User Format (see Cerberus: User) if the user format differs.

UnicodeLogFile Description If ON, outputs log file information to a unicode compliant log file.
Part
  • ON
  • OFF
Default OFF
Remarks

By default, Engine's log file is in a single byte ANSI format file. If Unicode is enabled and the database contains double byte character object names, the log can be converted to Unicode format by setting UnicodeLogFile = ON.

  Online & Instructor-Led Courses | Training Videos | Webinar Recordings
© Alterian. All Rights Reserved. | Privacy Policy | Legal Notice